#!/bin/sh
echo 'start analysis click data'
currDate="`date +%Y-%m-%d`"
echo "now '$currDate'"
/opt/lagou/server/hive-2.3.7/bin/hive -e "USE userclick;insert into user_info select count(distinct id) active_num,to_date(click_time) datestr  from user_clicks group by to_date(click_time)"
